using System;
using System.Collections.Generic;
using System.Text;
using DTOLayer;
using BUSLayer;
using System.Data.OleDb;
using System.Data;

namespace BUSLayer
{
   public class SQLNhieuHonHaiBangBUS
    {
       public static List<SoTietKiemDTO> LaySoTietKiem_tenLoaiTietKiem_MaSoTietKiem(long ma, string ten)
       {
           List<SoTietKiemDTO> list = new List<SoTietKiemDTO>();
           list = BUSLayer.SQLNhieuHonHaiBangDAO.LaySoTietKiem_tenLoaiTietKiem_MaSoTietKiem(ma, ten);
           return list;
       }
      
       public static List<BaoCaoDoanhSoNgayDTO> TinhDoanhSoNgay(DateTime ngaybc)
       {
           List<BaoCaoDoanhSoNgayDTO> ls = new List<BaoCaoDoanhSoNgayDTO>();
           ls = SQLNhieuHonHaiBangDAO.TinhDoanhSoNgay(ngaybc);
           return ls;
       }
       //
       public static List<BaoCaoThangDTO> BaoCaoDongMoSo(long mltk, int thang, int nam)
       {
           List<BaoCaoThangDTO> ls = new List<BaoCaoThangDTO>();
           ls = SQLNhieuHonHaiBangDAO.BaoCaoDongMoSo(mltk, thang, nam);
           return ls;
       }
       public static List<BaoCaoThangDTO> BaoCaoDongMoSoSuLyHam(long mltk, int thang, int nam)
       {
           List<BaoCaoThangDTO> ls = new List<BaoCaoThangDTO>();
           ls = SQLNhieuHonHaiBangDAO.BaoCaoDongMoSoSuLyHam(mltk, thang, nam);
           return ls;
       }
       public static DataTable ChuyenListBaoCaoDSNgay_DataTable(List<BaoCaoDoanhSoNgayDTO> ls)
       {
           DataTable kq = SQLNhieuHonHaiBangDAO.ChuyenListBaoCaoDSNgay_DataTable(ls);
           return kq;
       }
       public static DataTable ChuyenListBaoCaoMoDongSoThang_DataTable(List<BaoCaoThangDTO> ls)
       {
           DataTable kq = SQLNhieuHonHaiBangDAO.ChuyenListBaoCaoMoDongSoThang_DataTable(ls);
           return kq;
       }
       public static DataTable LaySoCoLoaiTietKiemKhongKyHan()//kyhan=0
       {
           DataTable dt;
           dt = SQLNhieuHonHaiBangDAO.LaySoCoLoaiTietKiemKhongKyHan();
           return dt;
       }
       public static double LayKyHanThemMaSo(long maso)
       {
           double kq = SQLNhieuHonHaiBangDAO.LayKyHanThemMaSo(maso);
           return kq;
       }
    }
}
